8 / 18

SQL tables and foreign keysURL copied

direction: right
users: {
  shape: sql_table
  icon: "https://api.iconify.design/mdi:account-group.svg"
  id: int {constraint: primary_key}
  email: string {constraint: unique}
  created_at: timestamp
}

orders: {
  shape: sql_table
  icon: "https://api.iconify.design/mdi:receipt-text-outline.svg"
  id: int {constraint: primary_key}
  user_id: int {constraint: foreign_key}
  total: decimal
  status: string
}

order_items: {
  shape: sql_table
  icon: "https://api.iconify.design/mdi:package-variant-closed.svg"
  id: int {constraint: primary_key}
  order_id: int {constraint: foreign_key}
  sku: string
  qty: int
  price: decimal
}

orders.user_id -> users.id
order_items.order_id -> orders.id
Commerce Schema
Copied
```d2
---
title: Commerce Schema
width: 90vw
height: 560px
layout: elk
---
direction: right
users: {
  shape: sql_table
  icon: "https://api.iconify.design/mdi:account-group.svg"
  id: int {constraint: primary_key}
  email: string {constraint: unique}
  created_at: timestamp
}

orders: {
  shape: sql_table
  icon: "https://api.iconify.design/mdi:receipt-text-outline.svg"
  id: int {constraint: primary_key}
  user_id: int {constraint: foreign_key}
  total: decimal
  status: string
}

order_items: {
  shape: sql_table
  icon: "https://api.iconify.design/mdi:package-variant-closed.svg"
  id: int {constraint: primary_key}
  order_id: int {constraint: foreign_key}
  sku: string
  qty: int
  price: decimal
}

orders.user_id -> users.id
order_items.order_id -> orders.id
```